Overview

Dataset Statistics

Number of Variables 9
Number of Rows 301
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 2
Duplicate Rows (%) 0.7%
Total Size in Memory 87.6 KB
Average Row Size in Memory 298.1 B
Variable Types
  • Categorical: 5
  • Numerical: 4

Dataset Insights

Year is skewed Skewed
Selling_Price is skewed Skewed
Present_Price is skewed Skewed
Kms_Driven is skewed Skewed
Car_Name has a high cardinality: 98 distinct values High Cardinality
Owner has constant length 1 Constant Length

Variables

Car_Name

categorical

Approximate Distinct Count 98
Approximate Unique (%) 32.6%
Missing 0
Missing (%) 0.0%
Memory Size 22.0 KB
  • The largest value (city) is over 1.62 times larger than the second largest value (corolla altis)

Length

Mean 9.8571
Standard Deviation 6.5602
Median 8
Minimum 3
Maximum 25

Sample

1st row ritz
2nd row sx4
3rd row ciaz
4th row wagon r
5th row swift

Letter

Count 2408
Lowercase Letter 2074
Space Separator 291
Uppercase Letter 334
Dash Punctuation 0
Decimal Number 263

Year

numerical

Approximate Distinct Count 16
Approximate Unique (%) 5.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.7 KB
Mean 2013.6279
Minimum 2003
Maximum 2018
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Year is skewed left (γ1 = -1.24)

Quantile Statistics

Minimum 2003
5-th Percentile 2008
Q1 2012
Median 2014
Q3 2016
95-th Percentile 2017
Maximum 2018
Range 15
IQR 4

Descriptive Statistics

Mean 2013.6279
Standard Deviation 2.8916
Variance 8.3611
Sum 606102
Skewness -1.24
Kurtosis 1.4881
Coefficient of Variation 0.001436
  • Year is not normally distributed (p-value 4.281618626859699e-10)
  • Year has 7 outliers

Selling_Price

numerical

Approximate Distinct Count 156
Approximate Unique (%) 51.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.7 KB
Mean 4.6613
Minimum 0.1
Maximum 35
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Selling_Price is skewed right (γ1 = 2.481)

Quantile Statistics

Minimum 0.1
5-th Percentile 0.25
Q1 0.9
Median 3.6
Q3 6
95-th Percentile 14.5
Maximum 35
Range 34.9
IQR 5.1

Descriptive Statistics

Mean 4.6613
Standard Deviation 5.0828
Variance 25.835
Sum 1403.05
Skewness 2.481
Kurtosis 8.7359
Coefficient of Variation 1.0904
  • Selling_Price is not normally distributed (p-value 5.444085161970238e-16)
  • Selling_Price has 17 outliers

Present_Price

numerical

Approximate Distinct Count 147
Approximate Unique (%) 48.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.7 KB
Mean 7.6285
Minimum 0.32
Maximum 92.6
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Present_Price is skewed right (γ1 = 4.0628)

Quantile Statistics

Minimum 0.32
5-th Percentile 0.54
Q1 1.2
Median 6.4
Q3 9.9
95-th Percentile 22.78
Maximum 92.6
Range 92.28
IQR 8.7

Descriptive Statistics

Mean 7.6285
Standard Deviation 8.6441
Variance 74.7207
Sum 2296.17
Skewness 4.0628
Kurtosis 31.157
Coefficient of Variation 1.1331
  • Present_Price is not normally distributed (p-value 6.550121713558577e-17)
  • Present_Price has 14 outliers

Kms_Driven

numerical

Approximate Distinct Count 206
Approximate Unique (%) 68.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.7 KB
Mean 36947.206
Minimum 500
Maximum 500000
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Kms_Driven is skewed right (γ1 = 6.4039)

Quantile Statistics

Minimum 500
5-th Percentile 3500
Q1 15000
Median 32000
Q3 48767
95-th Percentile 80000
Maximum 500000
Range 499500
IQR 33767

Descriptive Statistics

Mean 36947.206
Standard Deviation 38886.8839
Variance 1.5122e+09
Sum 1.1121e+07
Skewness 6.4039
Kurtosis 67.4101
Coefficient of Variation 1.0525
  • Kms_Driven is not normally distributed (p-value 4.732802408738394e-09)
  • Kms_Driven has 8 outliers

Fuel_Type

categorical

Approximate Distinct Count 3
Approximate Unique (%) 1.0%
Missing 0
Missing (%) 0.0%
Memory Size 20.9 KB
  • The largest value (Petrol) is over 3.98 times larger than the second largest value (Diesel)

Length

Mean 5.9801
Standard Deviation 0.2441
Median 6
Minimum 3
Maximum 6

Sample

1st row Petrol
2nd row Diesel
3rd row Petrol
4th row Petrol
5th row Diesel

Letter

Count 1800
Lowercase Letter 1495
Space Separator 0
Uppercase Letter 305
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Petrol, Diesel) take over 50.0%
  • The largest value (petrol) is over 3.98 times larger than the second largest value (diesel)

Seller_Type

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Memory Size 21.3 KB
  • The largest value (Dealer) is over 1.84 times larger than the second largest value (Individual)

Length

Mean 7.4086
Standard Deviation 1.9138
Median 6
Minimum 6
Maximum 10

Sample

1st row Dealer
2nd row Dealer
3rd row Dealer
4th row Dealer
5th row Dealer

Letter

Count 2230
Lowercase Letter 1929
Space Separator 0
Uppercase Letter 301
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Dealer, Individual) take over 50.0%
  • The largest value (dealer) is over 1.84 times larger than the second largest value (individual)

Transmission

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Memory Size 21.0 KB
  • The largest value (Manual) is over 6.52 times larger than the second largest value (Automatic)

Length

Mean 6.3987
Standard Deviation 1.0201
Median 6
Minimum 6
Maximum 9

Sample

1st row Manual
2nd row Manual
3rd row Manual
4th row Manual
5th row Manual

Letter

Count 1926
Lowercase Letter 1625
Space Separator 0
Uppercase Letter 301
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Manual, Automatic) take over 50.0%
  • The largest value (manual) is over 6.52 times larger than the second largest value (automatic)

Owner

categorical

Approximate Distinct Count 3
Approximate Unique (%) 1.0%
Missing 0
Missing (%) 0.0%
Memory Size 19.4 KB
  • The largest value (0) is over 29.0 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 301
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 29.0 times larger than the second largest value (1)
  • Owner has words of constant length

Interactions

Correlations

Missing Values